{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["AR_UP","Macro test"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"AR_UP","index":0,"n_rows":4,"n_cols":77,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"HEADER",null,null,null,null,null,null,"G/L LINE ITEMS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A/R LINE ITEMS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAX",null,null,null,"AMOUNT",null,null,"CO / PA CHARACTERISTICS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03 CHAR","10 CHAR","04 CHAR","06 CHAR","11 CHAR","14 CHAR","12 CHAR","06 CHAR","06 CHAR","04 CHAR","03 CHAR","04 CHAR","03 CHAR","10 CHAR","10 CHAR","10 CHAR","10 CHAR","06 CHAR","03 CHAR","15 CHAR","03 CHAR","03 CHAR","10 CHAR","10 CHAR","02 CHAR","06 CHAR",null,"14 CHAR"]
["Document Number","Header Text","Company Code","Document Date","Posting Date","Document Type","Document Reference Number","Accounting Principle","Item number","G/L Account","Allocation number","Item Text","Reference Key 1","Reference Key 2","Reference Key 3","Tax Code","Profit Center","Cost\nCentre","Trading\nPartner","Company Code","WBS Element","Activity Type","Tax Jurisdiction","Personnel number","Movement type","Quantity","Base Unit of Measure","Customer","AR movement type","Allocation number","Item text","Reference Key 1","Reference Key 2","Reference Key 3","Tax code","Company Code","Special G/L\nIndicator","Baseline Date For Due Date Calculation","Terms of Payment Key","Partner Bank Type","Tax Jurisdiction","Reason Code","G/L account","Tax code","Tax Jurisdiction","Direct tax","Currency","Amount","Base amount","Country","Customer","Repertoire owner","Label","ArtistCode","UPC","ISRC","Genre","Exploitation","Partner type","Product life cycle","Commercial model","Price level","R2 Project Code","Segment","Final customer","Digital price code","Product type","Country of sales","Data source","Transaction Type","Deal type","Deal parent number","Deal sub number","Activity owner","Sales period YYYYMM","WBS Element","Local Article Number"]
["AC_DOC_NO                                                                                           ","HE_HEADER_TXT                                                                                       ","HE_COMP_CODE                                                                                        ","HE_DOC_DATE                                                                                         ","HE_PSTNG_DATE                                                                                       ","HE_DOC_TYPE                                                                                         ","HE_REF_DOC_NO                                                                                       ","HE_ACC_PRINCIPLE","GL_ITEMNO_ACC                                                                                       ","GL_GL_ACCOUNT                                                                                       ","GL_ALLOC_NMBR                                                                                       ","GL_ITEM_TEXT                                                                                        ","GL_REF_KEY_1                                                                                        ","GL_REF_KEY_2                                                                                        ","GL_REF_KEY_3                                                                                        ","GL_TAX_CODE                                                                                         ","GL_PROFIT_CTR                                                                                       ","GL_COSTCENTER                                                                                       ","GL_TRADE_ID                                                                                         ","GL_COMP_CODE                                                                                        ","GL_WBS_ELEMENT                                                                                      ","GL_ACTTYPE                                                                                          ","GL_TAXJURCODE","GL_PERNR                                                                                            ","GL_RMVCT                                                                                          ","GL_QUANTITY","GL_BASE_UOM","AR_CUSTOMER                                                                                         ","AR_RMVCT","AR_ALLOC_NMBR                                                                                       ","AR_ITEM_TEXT                                                                                        ","AR_REF_KEY_1                                                                                        ","AR_REF_KEY_2                                                                                        ","AR_REF_KEY_3                                                                                        ","AR_TAX_CODE                                                                                         ","AR_COMP_CODE                                                                                        ","AR_SP_GL_IND                                                                                        ","AR_BLINE_DATE","AR_PMNTTRMS","AR_PARTNER_BK","AR_TAXJURCODE","AR_REASON_CODE","TX_GL_ACCOUNT                                                                                       ","TX_TAX_CODE                                                                                         ","TX_TAXJURCODE","TX_DIRECT_TAX                                                                                       ","AM_CURRENCY                                                                                         ","AM_AMT_DOCCUR                                                                                       ","AM_AMT_BASE                                                                                         ","CO_LAND1                                                                                            ","CO_KNDNR","CO_WW001                                                                                            ","CO_WW002                                                                                            ","CO_WW003                                                                                            ","CO_WW004                                                                                            ","CO_WW005                                                                                            ","CO_WW007                                                                                            ","CO_WW008                                                                                            ","CO_WW009                                                                                            ","CO_WW011                                                                                            ","CO_WW013                                                                                            ","CO_WW014                                                                                            ","CO_WW016                                                                                            ","CO_WW017                                                                                            ","CO_WW018                                                                                            ","CO_WW019                                                                                            ","CO_WW020                                                                                            ","CO_WW021                                                                                            ","CO_WW022                                                                                            ","CO_WW023                                                                                            ","CO_WW025","CO_WW026","CO_WW027","CO_WW028","CO_WW029                                                                                           ","CO_PSPNR","CO_WW030"]

{"sheet":"Macro test","index":1,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Account","Assignment","Document Number","Document Type","Document Date","Day","Month","Year","Special G/L ind.","Amount in local currency",null,"Local Currency","Text","Reference"]
["DSL","xxx",1,"CA","2014-04-14",null,null,null,null,-343.2,null,"GBP","test","xxxx"]
["DSL","xxx",2,"IA","2014-04-14",null,null,null,null,492,null,"GBP","test","xxxx"]
["DSL","xxx",3,"IA","2014-04-15",null,null,null,null,164.64,null,"GBP","test","xxxx"]
["DSL","xxx",4,"IA","2014-04-15",null,null,null,null,458.47,null,"GBP","test","xxxx"]
["DSL","xxx",5,"IA","2014-04-15",null,null,null,null,480.48,null,"GBP","test","xxxx"]